lea cohen
Member
Members
Forum Posts: 246
Member Since:
March 10, 2016
March 10, 2016
Offline
Hi, I have attached an excel file
I want to set in it that I will type the time 809 and
it will translate it to 08:09 time format with text functions.
Thank you for your help and reply to the file.
Thank you very much!!! Leah
Jessica Stewart
Northern USA
Member
Members
Trusted Members
Trusted Members
Forum Posts: 219
Member Since:
February 13, 2021
February 13, 2021
Offline
Riny van Eekelen
Örnsköldsvik, Sweden
Moderator
Members
Trusted Members
Moderators
Trusted Members
Moderators
Forum Posts: 852
Member Since:
January 31, 2022
January 31, 2022
Offline
When you enter 0018 in a 'General' formatted cell, Excel ignores the leading zeroes. In such a case, the formula joins an empty string with ":18"
Knowing that these type of entries may occur, format columns B and D as text first. Then enter 0018 and Excel will not remove the leading zeroes.
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: casey zweig, david gavi
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1917
SunnyKow: 1432
Anders Sehlstedt: 900
Purfleet: 414
Frans Visser: 346
David_Ng: 306
Hans Hallebeek: 289
lea cohen: 246
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
david gavi
Rick KISA
Jan Elenbaas
Ranjeet Wankhade
Sugata Maity
Karen McCarron
Amanda Zibell
Kevin Sanderson
wer klaus
Richard Gower
Forum Stats:
Groups: 3
Forums: 24
Topics: 6879
Posts: 30150
Member Stats:
Guest Posters: 49
Members: 33698
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —