Forcing Text
I've got an Excel template that users enter data into. We have Customer ID's
with leading zeros, but Excel cuts them off and treats them as numeric values. Is there any way I can define a column as text so the user can enter 0000456 without having to key a ' before the entry? I've tried defining the column using Data = Text to Columns = Text, but that isn't working. |
Forcing Text
Select the column, right click, select format cells, select text, click OK
and you're done. Dave -- Brevity is the soul of wit. "Kirk P." wrote: I've got an Excel template that users enter data into. We have Customer ID's with leading zeros, but Excel cuts them off and treats them as numeric values. Is there any way I can define a column as text so the user can enter 0000456 without having to key a ' before the entry? I've tried defining the column using Data = Text to Columns = Text, but that isn't working. |
Forcing Text
Select the column and FormatCellsNumberText.
Gord Dibben MS Excel MVP On Tue, 26 Sep 2006 11:39:01 -0700, Kirk P. wrote: I've got an Excel template that users enter data into. We have Customer ID's with leading zeros, but Excel cuts them off and treats them as numeric values. Is there any way I can define a column as text so the user can enter 0000456 without having to key a ' before the entry? I've tried defining the column using Data = Text to Columns = Text, but that isn't working. |
All times are GMT +1. The time now is 12:59 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com