Forum Discussion
Nadine75
Feb 25, 2019Copper Contributor
Excel Format help
Hi there,
Would anyone know how I can format a column of an excel spreadsheet to change numbers that are exported into the spreadsheet in the format e.g. I107492 - but i would prefer them to be in the format 10749-2 - can I somehow custom format the cells to all change to the new format?
Thanks.
1 Reply
- SergeiBaklanDiamond Contributor
Hi,
If that's the number like 107492 you may apply custom number format (Ctrl+1) as #-#
If that's the text "107492" or "I107492" or any other one when use formulas to convert the text.