Format Number (custom)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want a custom type that will take '5W' and put a zero in front, making it
'05W'. I used the 00 custom type and it would turn 5 into 05 but I haven't
found a working solution for the integer and character combination.
 
This worked but I forgot to mention that if 05W or 15W was entered I want it
left alone. "0"@ added the zero to the beginning turning it into 005W or
015W.
 
barryderay,

A custom format of 0?W works for me in XL97

HTH

Sandy
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Number Format (custom) 2
Format Cells for Hexidecimal (custom?) 1
Custom a number - Excel 2007 with Vista OS 14
Custom Number Format for text 8
format colon 2
Excel 2003 - Time Formats 5
ViewSonic VG2757V-2K Display with Inbuilt Webcam and Multifunctional Docking Station Unboxing 4
General Format to Custom format problem 1

Back
Top