how can i get a cell to hold a zero in front of a digit ie. 01 or.
I have tried checking the zero values box but still just takes the zero from
the front which I need for the table I am trying to plan. I don't want any decimal points in front |
You can do it three ways
1) If the 'number' you want to end up with is fixed length, say six characters, then FormatCells...Custom000000 will do it 2) Format the cells as text in advance of entry 3) Prefix with a single apostrophe ('). It will not show but will treat the entry as text -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "Southern Belle" <Southern wrote in message ... I have tried checking the zero values box but still just takes the zero from the front which I need for the table I am trying to plan. I don't want any decimal points in front |
Use a custom numeric format like 00 or precede entry with an apostrophe or
format as text before you enter it Regards, Peo Sjoblom "Southern Belle" <Southern wrote in message ... I have tried checking the zero values box but still just takes the zero from the front which I need for the table I am trying to plan. I don't want any decimal points in front |
All times are GMT +1. The time now is 04:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com